Problem Note 56091: The Load_DM_Geo_prod_exception ETL job might generate "ERROR: No data in ..."
 |  |  |  |  |
The SAS® Revenue Optimization Load_DM_Geo_prod_exception extract, transform, load (ETL) job might generate one of the following errors in the Load_DM_Geo_prod_exception.log..di_etl_geo_prod_exception.<#>.log file.
ERROR: No data in INVENTORY_FACT
ERROR: No data in COST_FACT_CURRENT
ERROR: No data in PRICE_FACT_CURRENT
These errors occur when the specified data set has no records in the partition.
The workaround for this issue is to ensure that at least one inventory, current cost, and current price record is loaded into each partition.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
| SAS System | SAS Retail Forecasting | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M1 |
| Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M1 | ||
A fix for this issue for SAS Revenue Optimization 5.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P20.html#56091A fix for this issue for SAS Size Optimization 3.2_M4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/P21.html#56091| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-08-13 09:29:14 |
| Date Created: | 2015-07-01 13:30:22 |